Live freelance tracking. Raw descriptions turned into structured data. Find your next tech project without the noise.
peopleperhour.com 🟡 2026-05-11
🔹 Large-scale web scraping and structured database creation
👤 Client: 🇬🇧 United Kingdom Member since ****
💰 Price: $20
🚩 Problem: Need experienced data extraction and structuring specialist for a large-scale project with over 100K entries.
📦 Existing: Not specified
Specifications:
[Stack] Web scraping tools (e.g., Scrapy, BeautifulSoup)
[Stack] Excel/Google Sheets for database generation
[Format] Structured Excel database fields: barcode, name, category, pricePristine, priceGood, priceFair, pricePoor, image_url
[Method] Pricing logic based on website trade-in/buying prices (not selling prices)
[Security] Ensure data privacy and security during scraping and database generation
[UI/UX] Not applicable
Workflow:
1. Analyze World of Books website structure to identify product data extraction points.
2. Develop web scraping scripts using chosen tools (e.g., Scrapy, BeautifulSoup) to extract required fields.
3. Generate pricing based on trade-in/buying prices and apply logic: Pristine = website trade-in price; Good = 50% less than Pristine; Fair = 75% less than Pristine; Poor = 95% less than Pristine.
4. Download product images from the website and rename them using barcode.jpg format.
5. Match image references correctly within the database.
6. Structure data into a well-organized Excel/Google Sheets file with specified fields.
7. Test and validate scraped data for accuracy and completeness.